Formal classification of integrity constraints in spatiotemporal database applications

نویسندگان

  • Mehrdad Salehi
  • Yvan Bédard
  • Mir Abolfazl Mostafavi
  • Jean Brodeur
چکیده

Imposing integrity constraints is an efficient way to improve data quality in databases. Effective imposition of integrity constraints requires their precise distinction and specification. Despite a few efforts for enhancing the distinction and specification of the integrity constraints in spatial and spatiotemporal databases by their classifications, these classifications fail to precisely distinguish between inherently dissimilar integrity constraints. Furthermore, the existing classifications provide imprecise definitions for the classes of integrity constraints. Such shortcomings explain why still diverse terms are used to refer to a same spatial integrity constraint. In this paper, we propose a formal and more exhaustive classification of the integrity constraints in spatiotemporal databases relying on their nature with respect to space, time, and themes. Moreover, a terminology for the integrity constraints of spatiotemporal databases is presented. Finally, we discuss the advantages of the proposed classification in the specification of integrity constraints. & 2011 Elsevier Ltd. All rights reserved.

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Logical Consistency for Vague Spatiotemporal Objects and Relations

Vagueness is often considered as an inherent property of spatiotemporal phenomena. In order to reduce this vagueness, integrity constraints should be defined to improve logical consistency of spatiotemporal databases. However, existing constraints are not adapted to control logical consistency of vague spatiotemporal objects because they are initially defined for crisp (or non–fuzzy) objects. W...

متن کامل

Database Integrity Checking

Integrity constraints (or simply “constraints”) are formal representations of invariant conditions for the semantic correctness of database records. Constraints can be expressed in declarative languages such as datalog, predicate logic, or SQL. This article highlights the historical background of integrity constraints and the essential features of their simplified incremental evaluation. It con...

متن کامل

Encyclopedia of Database Technologies and Applications

Active Issues in Databases 6 Business Rules in Databases 60 Managing Inconsistent Databases Using Active Integrity Constraints 87 Active services for federated databases 93 Active Database Management Systems 131 Real-Time Databases Databases and Digital Libraries Technologies 1 Text Categorization 42 Approaches to the document versioning issue in digital libraries 130 An XML Multi-tier Pattern ...

متن کامل

Fuzzy and Uncertain Spatio-Temporal Database Models: A Constraint-Based Approach

In this paper a constraint-based generalised object-oriented database model is adapted to manage spatiotemporal information. This adaptation is based on the definition of a new data type, which is suited to handle both temporal and spatial information. Generalised constraints are used to describe spatio-temporal data, to enforce integrity rules on databases, to specify the formal semantics of a...

متن کامل

Modeling spatial constraints in conceptual database design of network applications

This paper describes the problems found in geographic databases design during the conceptual modeling of real world elements that are related by a network structure. It is believed that is possible to reach a better quality of the geographical data if spatial integrity constraints about the elements on a network are specified in a conceptual level. Hence, the purpose of this paper is to expand ...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

عنوان ژورنال:
  • J. Vis. Lang. Comput.

دوره 22  شماره 

صفحات  -

تاریخ انتشار 2011